CREATE TABLE [dbo].[ExpoCad_Prod]
(
[Meet_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpoCad_Prod_Meet_ID] DEFAULT (''),
[ExpoCad_Type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpoCad_Prod_ExpoCad_Type] DEFAULT (''),
[Product_Code] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpoCad_Prod_Product_Code] DEFAULT (''),
[Premium_1] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpoCad_Prod_Premium_1] DEFAULT (''),
[Qty_1] [int] NOT NULL CONSTRAINT [DF_ExpoCad_Prod_Qty_1] DEFAULT ((0)),
[Premium_2] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpoCad_Prod_Premium_2] DEFAULT (''),
[Qty_2] [int] NOT NULL CONSTRAINT [DF_ExpoCad_Prod_Qty_2] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ExpoCad_Prod] ADD CONSTRAINT [PK_ExpoCad_Prod] PRIMARY KEY NONCLUSTERED ([Meet_ID], [ExpoCad_Type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpoCad_ProdExpoCad_Type] ON [dbo].[ExpoCad_Prod] ([ExpoCad_Type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpoCad_ProdPremium_1] ON [dbo].[ExpoCad_Prod] ([Premium_1]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpoCad_ProdPremium_2] ON [dbo].[ExpoCad_Prod] ([Premium_2]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpoCad_ProdProduct_Code] ON [dbo].[ExpoCad_Prod] ([Product_Code]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ExpoCad_Prod] TO [IMIS]
GRANT SELECT ON  [dbo].[ExpoCad_Prod] TO [IMIS]
GRANT INSERT ON  [dbo].[ExpoCad_Prod] TO [IMIS]
GRANT DELETE ON  [dbo].[ExpoCad_Prod] TO [IMIS]
GRANT UPDATE ON  [dbo].[ExpoCad_Prod] TO [IMIS]
GO